[QUIZ] Test your understanding of SQL - Part 1

SQL is a familiar term if you pay attention to the computer field. So what do you know about SQL?

  1. Question 1: What does SQL mean?
    1. Structured Question Language
    2. Structured Query Language
    3. Strong Question Language
  2. Question 2: Which SQL statement is used to retrieve data from the database?
    1. GET
    2. OPEN
    3. SELECT
    4. EXTRACT
  3. Question 3: Which SQL statement is used to update data in the database?
    1. MODIFY
    2. SAVE AS
    3. SAVE
    4. UPDATE
  4. Question 4: Which SQL statement is used to delete data from the database?
    1. REMOVE
    2. DELETE
    3. COLLAPSE
    4. DROP
  5. Question 5: Which SQL statement is used to add new data to the database?
    1. ADD RECORD
    2. ADD NEW
    3. INSERT INTO
    4. NEW INSERT
  6. Question 6: In SQL, how to select a column named "FirstName" from the "Persons" table?
    1. EXTRACT FirstName FROM Persons
    2. SELECT FirstName FROM Persons
    3. SELECT Persons.FirstName
  7. Question 7: In SQL, how to select all columns from the "Persons" table?
    1. SELECT [all] FROM Persons
    2. SELECT * FROM Persons
    3. SELECT * .Persons
    4. SELECT Persons
  8. Question 8: In SQL, how to select all records from the "Persons" table in which the value of "FirstName" column is "Peter"?
    1. SELECT [all] FROM Persons WHERE FirstName = 'Peter'
    2. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
    3. SELECT * FROM Persons WHERE FirstName <> 'Peter'
    4. SELECT * FROM Persons WHERE FirstName = 'Peter'
  9. Question 9: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column begins with "a"?
    1. SELECT * FROM Persons WHERE FirstName LIKE '% a'
    2. SELECT * FROM Persons WHERE FirstName LIKE 'a%'
    3. SELECT * FROM Persons WHERE FirstName = '% a%'
    4. SELECT * FROM Persons WHERE FirstName = 'a'
  10. Question 10: The OR operator displays a record if the retrieved data only needs to satisfy one of the listed conditions. The AND operator displays the record if the retrieved data satisfies all the listed conditions.
    1. It's correct
    2. False
  11. Question 11: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column is "Peter" and "LastName" is "Jackson"?
    1. SELECT * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'
    2. SELECT * FROM Persons WHERE FirstName <> 'Peter' AND LastName <> 'Jackson'
    3. SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons
  12. Question 12: In SQL, how to select all records from the "Persons" table in which "LastName" is sorted alphabetically and is in "Hansen" and "Pettersen" (including 2 values). this)
    1. SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName <'Pettersen'
    2. SELECT LastName> 'Hansen' AND LastName <'Pettersen' FROM Persons
    3. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
  13. Question 13: Which SQL statement is used to return unique values ​​in the table?
    1. SELECT UNIQUE
    2. SELECT DISTINCT
    3. SELECT DIFFERENT
  14. Question 14: Which SQL command is used to sort the result set?
    1. SORT BY
    2. SORT
    3. ORDER
    4. ORDER BY
  15. Question 15: In SQL, how can I return all records from the "Persons" table sorted in descending order according to "FirstName"?
    1. SELECT * FROM Persons SORT BY 'FirstName' DESC
    2. SELECT * FROM Persons ORDER BY FirstName DESC
    3. SELECT * FROM Persons SORT 'FirstName' DESC
    4. SELECT * FROM Persons ORDER FirstName DESC
Update 24 May 2019
learn sqldatabasesql quizzesdatabase testquiz sqlcheck sqlsql knowledgesql testsql exercises

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile